SELECT Titles.Title, Titles.ISBN, 
       Authors.FirstName, Authors.LastName, 
       Titles.YearPublished, Publishers.PublisherName
FROM 
   (Publishers INNER JOIN Titles ON Publishers.PublisherID = Titles.PublisherID) 
INNER JOIN 
   (Authors INNER JOIN AuthorISBN ON Authors.AuthorID = AuthorISBN.AuthorID) 
ON Titles.ISBN = AuthorISBN.ISBN
